Skip to main content  


LEI 6.x: "Overwrite Existing Data" Fails if Target Table Schema Differs from Connection User

Technote Number: 1107266

This issue was reported to Lotus software Quality Engineering and has been
addressed in LEI 6.0.3 and 6.5.

Excerpt from the Lotus Notes and Domino Release 6.0.3 MR fix list (available at

SPR# SBOR5KYTZT - Fixed a problem where "overwrite existing data" failed when
the target table schema differed from the connection user. This regression was
introduced in 6.0.1.

If your target table is in a different schema than the username specified in
the Connection document, your Activity will fail. Upon performing the lookup
to overwrite existing data, LEI is not appending the schema defined in the
Activity. It is assuming that it is in the same schema as the ownername.


If the schema in which your table resides is the same as a defined user in the
database, specify that user in your Connection document, or

Create a Replication with Source as Master and do not allow any updates to the
source from the target.

Alternately, your Direct Transfer Activity could be changed to not overwrite
the existing data. A Command Activity could be created to clear the table,
which would then have the DT activity as a dependent activity.
More >

  Document options
Print this document
Print view

Search Advanced Search

  Fix list views

 RSS feeds   RSS
Subscribe to the fix list

Using this database
View notices

  HCL Support
HCL Support

    About HCL Privacy Contact